package com.woniuxy.oa.mapper;
 

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.woniuxy.oa.entity.Goods_purchase;

public interface Goods_purchaseMapper {
	Integer insertPurchaseGetGp_id(Goods_purchase goods_purchase);
	void updatePurchaseByGp_id(@Param("goods_purchase")Goods_purchase goods_purchase);
	void deletePuchaseByGp_id(Integer gp_id);
	//根据gp_id查询申购信息和员工信息
	Goods_purchase selectGoods_purchaseByGp_id(Integer gp_id);
	
	//分页查询：使用连接查询，两张表都有员工编号，有姓名条件就加条件，没有就查询全部
	List<Goods_purchase> selectGoods_purchaseConditionByName(String name,Integer pageIndex,Integer pageSize);
	//根据员工编号查询总记录条数
	Integer selectGoods_purchaseTotalRecordById(String name);
	
	
}
